
select codigo_filial,data_venda,sum(valor_pago) from loja_venda
where codigo_filial in ('000025','000026','000027','000033''000035','000053','000057')
and data_venda >= '20050101'and data_venda <= '20050119' and terminal = '999'
group by codigo_filial,data_venda order by codigo_filial
